<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
    <meta http-equiv="Content-Style-Type" content="text/css" />
    <!-- MOTW-DISABLED saved from url=(0014)about:internet -->
    <title>BirtStr</title>
    <link rel="StyleSheet" href="css/ScriptingReference.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" />
    <link rel="StyleSheet" href="webworks.css" type="text/css" media="all" />
    <script type="text/javascript" language="JavaScript1.2">
      <!--
        var  WebWorksRootPath = "";
      // -->
    </script>
  </head>
  <body>
    <div style="text-align: left;">
      <table cellspacing="0" summary="">
        <tr>
          <td>
            <a href="ScriptingReference.24.6.html"><img src="images/prev.gif" alt="Previous" border="0" /></a>
          </td>
          <td>
            <a href="ScriptingReference.24.8.html"><img src="images/next.gif" alt="Next" border="0" /></a>
          </td>
        </tr>
      </table>
    </div>
    <hr align="left" />
    <blockquote>
      <h2 class="RH1_Class">Class  <a name="267653">BirtStr</a></h2>
      <p class="b_Body"><a name="261858">The BirtStr class provides functions to manipulate strings, for example, to concatenate strings, trim extra spaces, get parts of a string, and display strings in lower or upper case. This class is static. The application cannot create instances of the class.</a></p>
      <h3 class="RH2_Method"><a name="261859">BirtStr.charLength</a></h3>
      <p class="b_Body"><a name="261860">This function returns the length of a given string.</a></p>
      <p class="N_sb_ScanBold"><a name="261861">Syntax</a></p>
      <div class="rs_RSyntax"><a name="261862">integer BirtStr.charLength( string source )</a></div>
      <p class="N_sb_ScanBold"><a name="261863">Parameter</a></p>
      <p class="RParameter"><a name="261864">source</a></p>
      <p class="bn_BodyNoLead"><a name="261865">String. The string to evaluate.</a></p>
      <p class="N_sb_ScanBold"><a name="261868">Returns</a></p>
      <p class="b_Body"><a name="261869">Integer. The number of characters in the specified string.</a></p>
      <p class="N_sb_ScanBold"><a name="261870">Examples</a></p>
      <p class="b_Body"><a name="261871">The following example returns the length of a specific string:</a></p>
      <div class="cf_CodeFirst"><a name="261872">BirtStr.charLength( "Julie Murphy" ) // returns 12</a></div>
      <p class="b_Body"><a name="261876">The following example returns the length of each value in the CustomerName field:</a></p>
      <div class="cf_CodeFirst"><a name="261877">BirtStr.charLength( row["CustomerName"] )</a></div>
      <h3 class="RH2_Method"><a name="263870">BirtStr.concat</a></h3>
      <p class="b_Body"><a name="263871">This function returns the string that results from concatenating specified strings.</a></p>
      <p class="N_sb_ScanBold"><a name="263872">Syntax</a></p>
      <div class="rs_RSyntax"><a name="263873">string BirtStr.concat( string source1, ..., sourceN )</a></div>
      <p class="N_sb_ScanBold"><a name="263874">Parameter</a></p>
      <p class="RParameter"><a name="263875">source1, ..., sourceN</a></p>
      <p class="bn_BodyNoLead"><a name="263876">String. The strings to concatenate.</a></p>
      <p class="N_sb_ScanBold"><a name="263877">Returns</a></p>
      <p class="b_Body"><a name="263878">String. The string that results from concatenating a series of strings.</a></p>
      <p class="N_sb_ScanBold"><a name="263879">Example</a></p>
      <p class="b_Body"><a name="263882">The following example returns a full address by concatenating values from multiple fields:</a></p>
      <div class="cf_CodeFirst"><a name="263883">BirtStr.concat( row["AddressLine1"], ", ", row["AddressLine2"], ", ", row["City"], " ", row["PostalCode"], "row["State"], ", ", row["Country"] )</a></div>
      <h3 class="RH2_Method"><a name="264323">BirtStr.indexOf</a></h3>
      <p class="b_Body"><a name="264324">This function returns the position of a specified substring in a given string.</a></p>
      <p class="N_sb_ScanBold"><a name="264325">Syntax</a></p>
      <div class="rs_RSyntax"><a name="264326">integer BirtStr.indexOf( sring target, string source, integer start )</a></div>
      <p class="N_sb_ScanBold"><a name="264327">Parameters</a></p>
      <p class="RParameter"><a name="264328">target</a></p>
      <p class="bn_BodyNoLead"><a name="264329">String. The substring to search for. The search is case-sensitive.</a></p>
      <p class="RParameter"><a name="264373">source</a></p>
      <p class="bn_BodyNoLead"><a name="264393">String. The string in which to look for a specified substring.</a></p>
      <p class="RParameter"><a name="264398">start</a></p>
      <p class="bn_BodyNoLead"><a name="264503">Integer. Optional. The position in the source string where the search starts. If you omit this argument, the function starts the search from the first character of the string.</a></p>
      <p class="N_sb_ScanBold"><a name="264330">Returns</a></p>
      <p class="b_Body"><a name="264331">Integer. The numerical position of the substring in the string. The first character of a string starts at 0. If the substring is not found, the function returns -1.</a></p>
      <p class="N_sb_ScanBold"><a name="264332">Examples</a></p>
      <p class="b_Body"><a name="264333">The following example returns the numeric position of specified characters in specific strings:</a></p>
      <div class="cf_CodeFirst"><a name="264334">BirtStr.indexOf( " ", "Julie Murphy" ) // returns 5</a></div>
      <div class="co_Code"><a name="264705">BirtStr.indexOf( "-", "ModelA-1234-567" ) // returns 6</a></div>
      <div class="co_Code"><a name="266548">BirtStr.indexOf( "-", "ModelA-1234-567", 7 ) // returns 11</a></div>
      <p class="b_Body"><a name="266569">The following example uses BirtStr.indexOf(&nbsp;) in conjunction with BirtStr.left(&nbsp;) to display the characters that precede the space character in a customer name. The BirtStr.left(&nbsp;) function extracts a substring of a specified length, starting from the first character. In this example, the length of the substring to display is equal to the numerical position of the space character.</a></p>
      <div class="cf_CodeFirst"><a name="266570">spaceCharPosition = BirtStr.indexOf( " ", row["customerName"] );</a></div>
      <div class="co_Code"><a name="266571">displayFirstName = BirtStr.left( row["customerName"], spaceCharPosition );</a></div>
      <p class="b_Body"><a name="266572">If the customer name is Julie Murphy, the expression returns Julie.</a></p>
      <h3 class="RH2_Method"><a name="264831">BirtStr.left</a></h3>
      <p class="b_Body"><a name="264832">This function extracts a substring of a specified length from a string, starting from the left-most, or first, character.</a></p>
      <p class="N_sb_ScanBold"><a name="264833">Syntax</a></p>
      <div class="rs_RSyntax"><a name="264834">string BirtStr.left( string source, integer n )</a></div>
      <p class="N_sb_ScanBold"><a name="264835">Parameters</a></p>
      <p class="RParameter"><a name="265142">source</a></p>
      <p class="bn_BodyNoLead"><a name="265143">String. The string from which to extract a substring.</a></p>
      <p class="RParameter"><a name="265144">n</a></p>
      <p class="bn_BodyNoLead"><a name="264839">Integer. The number of characters to extract, starting from the first character.</a></p>
      <p class="N_sb_ScanBold"><a name="264842">Returns</a></p>
      <p class="b_Body"><a name="265267">Sring. A substring of a specific length. </a></p>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="265268">If you omit n, the number of characters to extract, the function returns the first character only. </a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="265269">If n is zero, the function returns an empty string. </a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="265270">If n is greater than the length of the string, the function returns the entire string.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <p class="N_sb_ScanBold"><a name="264844">Examples</a></p>
      <p class="b_Body"><a name="264845">The following example returns substrings of various lengths from specific strings:</a></p>
      <div class="cf_CodeFirst"><a name="264846">BirtStr.left( "Julie Murphy", 5 ) // returns Julie</a></div>
      <div class="co_Code"><a name="264847">BirtStr.left( "Julie Murphy", 12 ) // returns Julie Murphy</a></div>
      <p class="b_Body"><a name="264849">The following example uses BirtStr.indexOf(&nbsp;) in conjunction with BirtStr.left(&nbsp;) to display the characters that precede the space character in a customer name. The BirtStr.left(&nbsp;) function extracts a substring of a specified length, starting from the first character. In this example, the length of the substring to display is equal to the numerical position of the space character.</a></p>
      <div class="cf_CodeFirst"><a name="264850">spaceCharPosition = BirtStr.indexOf( " ", row["customerName"] );</a></div>
      <div class="co_Code"><a name="264851">displayFirstName = BirtStr.left( row["customerName"], spaceCharPosition );</a></div>
      <p class="b_Body"><a name="264852">If the customer name is Julie Murphy, the expression returns Julie.</a></p>
      <h3 class="RH2_Method"><a name="265393">BirtStr.right</a></h3>
      <p class="b_Body"><a name="265394">This function extracts a substring of a specified length from a string, starting from the right-most, or last, character.</a></p>
      <p class="N_sb_ScanBold"><a name="265395">Syntax</a></p>
      <div class="rs_RSyntax"><a name="265396">String BirtStr.right( String source, integer n )</a></div>
      <p class="N_sb_ScanBold"><a name="265397">Parameters</a></p>
      <p class="RParameter"><a name="265398">source</a></p>
      <p class="bn_BodyNoLead"><a name="265399">String. The string from which to extract a substring.</a></p>
      <p class="RParameter"><a name="265400">n</a></p>
      <p class="bn_BodyNoLead"><a name="265401">Integer. The number of characters to extract, starting from the last character.</a></p>
      <p class="N_sb_ScanBold"><a name="265402">Returns</a></p>
      <p class="b_Body"><a name="265403">String. A substring of a specific length. </a></p>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="265404">If you omit n, the number of characters to extract, the function returns the last character only. </a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="265405">If n is zero, the function returns an empty string. </a></div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="265406">If n is greater than the length of the string, the function returns the entire string.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <p class="N_sb_ScanBold"><a name="265407">Examples</a></p>
      <p class="b_Body"><a name="265408">The following example returns substrings of various lengths from specific strings:</a></p>
      <div class="cf_CodeFirst"><a name="265409">BirtStr.right( "Julie Murphy", 6 ) // returns Murphy</a></div>
      <div class="co_Code"><a name="265410">BirtStr.right( "Julie Murphy", 12 ) // returns Julie Murphy</a></div>
      <p class="b_Body"><a name="265683">The following example uses BirtStr.right(&nbsp;) in conjunction with the BirtStr.indexOf(&nbsp;) and BirtStr.charLength(&nbsp;) functions to display the characters that appear after the space character in a customer name. This example assumes that the number of characters after the hyphen varies. Therefore, the length of the entire string (returned by BirtStr.charLength(&nbsp;)) minus the length up to the hyphen (returned by BirtStr.indexOf(&nbsp;)) is the number of characters to display.</a></p>
      <div class="cf_CodeFirst"><a name="265684">spaceCharPosition = BirtStr.indexOf( " ", row["customerName"] );</a></div>
      <div class="co_Code"><a name="265731">displayLastName = BirtStr.right( row["customerName"], (BirtStr.charLength( row["customerName"] - (spaceCharPosition + 1)) )</a></div>
      <p class="b_Body"><a name="265685">If the customer name is Julie Murphy, the expression returns Murphy. If the customer name is Kwai Li, the expression returns Li.</a></p>
      <h3 class="RH2_Method"><a name="265763">BirtStr.search</a></h3>
      <p class="b_Body"><a name="265764">This function returns the position of a specified substring in a given string. The substring can contain wildcard characters.</a></p>
      <p class="N_sb_ScanBold"><a name="265765">Syntax</a></p>
      <div class="rs_RSyntax"><a name="265766">integer BirtStr.search( string pattern, string source, integer index )</a></div>
      <p class="N_sb_ScanBold"><a name="265767">Parameters</a></p>
      <p class="RParameter"><a name="265768">pattern</a></p>
      <p class="bn_BodyNoLead"><a name="266046">String. The string pattern to search for. The search is case-insensitive. You can use the following wildcard characters in a pattern:</a></p>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><span style="font-family: &quot;Microsoft Sans Serif&quot;"><a name="266052">An asterisk (&nbsp;*&nbsp;) matches zero or more characters, including spaces</a></span>. For example, t*n matches tn, tin, and teen. </div>
            </td>
          </tr>
        </table>
      </div>
      <div class="b1_Bullet1_outer" style="margin-left: 0pt">
        <table border="0" cellspacing="0" cellpadding="0" summary="" role="presentation">
          <tr style="vertical-align: baseline">
            <td>
              <div class="b1_Bullet1_inner" style="width: 14.1732283464567pt; white-space: nowrap">
                <img src="Bullet.png" alt="*" border="0" width="6" height="6" />
              </div>
            </td>
            <td width="100%">
              <div class="b1_Bullet1_inner"><a name="266054">A question mark (?) matches exactly one character. For example, t?n matches tan, ten, tin, and ton. It does not match teen or tn.</a></div>
            </td>
          </tr>
        </table>
      </div>
      <p class="b_Body"><a name="307053">To match a literal asterisk or question mark in a string, precede those characters with two backslash characters (\\). For example, to find the substring R*10, use the following string pattern:</a></p>
      <div class="cfb_CodeFirst_Break"><a name="307079">"R\\*10"</a></div>
      <p class="RParameter"><a name="266022">source</a></p>
      <p class="bn_BodyNoLead"><a name="265769">String. The string in which to look for a specified substring.</a></p>
      <p class="RParameter"><a name="265770">index</a></p>
      <p class="bn_BodyNoLead"><a name="266100">Integer. Optional. The position in the source string where the search starts. If you omit this argument, the function starts the search from the first character of the string.</a></p>
      <p class="N_sb_ScanBold"><a name="266101">Returns</a></p>
      <p class="b_Body"><a name="266102">Integer. The numerical position of the substring in the string. The first character of a string starts at 0. If the substring is not found, the function returns -1.</a></p>
      <p class="N_sb_ScanBold"><a name="265777">Examples</a></p>
      <p class="b_Body"><a name="266358">The following example returns the numeric position of specified string patterns in specific strings:</a></p>
      <div class="cf_CodeFirst"><a name="266359">BirtStr.search( "XM?", "XMS-ModelA-1234-567" ) // returns 0</a></div>
      <div class="co_Code"><a name="266360">BirtStr.search( "ModelA*", "XMS-ModelA-1234-567" ) // returns 4</a></div>
      <div class="co_Code"><a name="266377">BirtStr.search( "-", "XMS-ModelA-1234-567", 4 ) // returns 10</a></div>
      <p class="b_Body"><a name="266308">The following example searches for the string pattern, S*A, in each value in the ProductCode field. If the product code is KBS5412A, the expression returns 2.</a></p>
      <div class="cf_CodeFirst"><a name="266214">BirtStr.search( "S*A", row["ProductCode"] )</a></div>
      <p class="b_Body"><a name="266580">The following example uses BirtStr.search(&nbsp;) in conjunction with BirtStr.left(&nbsp;) to display the characters that precede the string pattern, -Model*, in a product name. The BirtStr.left(&nbsp;) function extracts a substring of a specified length, starting from the first character. In this example, the length of the substring to display is equal to the numerical position of the string pattern.</a></p>
      <div class="cf_CodeFirst"><a name="266581">stringPatternPosition = BirtStr.search( "-Model*", row["productName"] );</a></div>
      <div class="co_Code"><a name="266597">displayString = BirtStr.left( row["productName"], stringPatternPosition );</a></div>
      <p class="b_Body"><a name="266582">If the product name is XMS-ModelA-1234, the expression returns XMS.</a></p>
      <h3 class="RH2_Method"><a name="266634">BirtStr.toLower</a></h3>
      <p class="b_Body"><a name="266635">This function converts all letters in a string to lowercase.</a></p>
      <p class="N_sb_ScanBold"><a name="266636">Syntax</a></p>
      <div class="rs_RSyntax"><a name="266637">string BirtStr.toLower( string source )</a></div>
      <p class="N_sb_ScanBold"><a name="266638">Parameter</a></p>
      <p class="RParameter"><a name="266639">source</a></p>
      <p class="bn_BodyNoLead"><a name="266640">String. The string to convert to lowercase.</a></p>
      <p class="N_sb_ScanBold"><a name="266641">Returns</a></p>
      <p class="b_Body"><a name="266642">String. The specified string in all lowercase letters</a></p>
      <p class="N_sb_ScanBold"><a name="266643">Example</a></p>
      <p class="b_Body"><a name="266644">The following example displays all the values in the productLine field in lowercase:</a></p>
      <div class="cf_CodeFirst"><a name="266645">BirtStr.toLower( row["productLine"] ) </a></div>
      <h3 class="RH2_Method"><a name="266740">BirtStr.toUpper</a></h3>
      <p class="b_Body"><a name="266741">This function converts all letters in a string to uppercase.</a></p>
      <p class="N_sb_ScanBold"><a name="266742">Syntax</a></p>
      <div class="rs_RSyntax"><a name="266743">string BirtStr.toUpper( string source )</a></div>
      <p class="N_sb_ScanBold"><a name="266744">Parameter</a></p>
      <p class="RParameter"><a name="266745">source</a></p>
      <p class="bn_BodyNoLead"><a name="266746">String. The string to convert to uppercase.</a></p>
      <p class="N_sb_ScanBold"><a name="266747">Returns</a></p>
      <p class="b_Body"><a name="266748">String. The specified string in all uppercase letters</a></p>
      <p class="N_sb_ScanBold"><a name="266749">Example</a></p>
      <p class="b_Body"><a name="266750">The following example displays all the values in the customerName field in uppercase:</a></p>
      <div class="cf_CodeFirst"><a name="266751">BirtStr.toUpper( row["customerName"] ) </a></div>
      <h3 class="RH2_Method"><a name="267084">BirtStr.trim</a></h3>
      <p class="b_Body"><span style="font-family: &quot;Microsoft Sans Serif&quot;"><a name="267147">This function returns a string with all leading and trailing blank characters removed. </a></span>It does not remove blank characters between words.</p>
      <p class="N_sb_ScanBold"><a name="267148">Syntax</a></p>
      <div class="rs_RSyntax"><a name="267149">string BirtStr.trim( string source )</a></div>
      <p class="N_sb_ScanBold"><a name="267150">Parameter</a></p>
      <p class="RParameter"><a name="267151">source</a></p>
      <p class="bn_BodyNoLead"><a name="267152">String. The string from which to remove leading and trailing blank characters.</a></p>
      <p class="N_sb_ScanBold"><a name="267153">Returns</a></p>
      <p class="b_Body"><a name="267154">String. A string with all leading and trailing blank characters removed.</a></p>
      <p class="N_sb_ScanBold"><a name="267155">Example</a></p>
      <p class="b_Body"><a name="267156">The following example uses BirtStr.trim(&nbsp;) to remove all leading and trailing blank characters from values in the FirstName and LastName data fields. </a></p>
      <div class="cf_CodeFirst"><a name="267157">BirtStr.trim( row["FirstName"]) + " " + BirtStr.trim(row["LastName"] )</a></div>
      <h3 class="RH2_Method"><a name="267249">BirtStr.trimLeft</a></h3>
      <p class="b_Body"><span style="font-family: &quot;Microsoft Sans Serif&quot;"><a name="267250">This function returns a string with all leading and trailing blank characters removed. </a></span>It does not remove blank characters between words.</p>
      <p class="N_sb_ScanBold"><a name="267251">Syntax</a></p>
      <div class="rs_RSyntax"><a name="267252">string BirtStr.trimLeft( string source )</a></div>
      <p class="N_sb_ScanBold"><a name="267253">Parameter</a></p>
      <p class="RParameter"><a name="267254">source</a></p>
      <p class="bn_BodyNoLead"><a name="267255">String. The string from which to remove leading blank characters.</a></p>
      <p class="N_sb_ScanBold"><a name="267256">Returns</a></p>
      <p class="b_Body"><a name="267257">String. A string with all leading blank characters removed.</a></p>
      <p class="N_sb_ScanBold"><a name="267258">Example</a></p>
      <p class="b_Body"><a name="267307">The following example concatenates a literal string with each value in the customerName field. BirtStr.trimLeft(&nbsp;) removes all blank characters preceding the customerName value so that there are no extra blank characters between the literal string and the customerName value.</a></p>
      <div class="cf_CodeFirst"><a name="267308">"Customer name: " + BirtStr.trimLeft( row["customerName"] )</a></div>
      <h3 class="RH2_Method"><a name="267327">BirtStr.trimRight</a></h3>
      <p class="b_Body"><span style="font-family: &quot;Microsoft Sans Serif&quot;"><a name="267328">This function returns a string with all trailing blank characters removed. </a></span>It does not remove blank characters between words.</p>
      <p class="N_sb_ScanBold"><a name="267329">Syntax</a></p>
      <div class="rs_RSyntax"><a name="267330">string BirtStr.trimRight( string source )</a></div>
      <p class="N_sb_ScanBold"><a name="267331">Parameter</a></p>
      <p class="RParameter"><a name="267332">source</a></p>
      <p class="bn_BodyNoLead"><a name="267333">String. The string from which to remove trailing blank characters.</a></p>
      <p class="N_sb_ScanBold"><a name="267334">Returns</a></p>
      <p class="b_Body"><a name="267335">String. A string with all trailing blank characters removed.</a></p>
      <p class="N_sb_ScanBold"><a name="267336">Example</a></p>
      <p class="b_Body"><a name="267541">The following example concatenates each value in the Comment field with a semicolon, then with a value in the Action field. BirtStr.trimRight(&nbsp;) removes all blank characters after the Comment value so that there are no extra blank characters between the Comment string and the semicolon.</a></p>
      <div class="cf_CodeFirst"><a name="267542">BirtStr.trimRight( row["Comment"]) + "; " + row["Action"] )</a></div>
    </blockquote>
    <hr align="left" />
    <table align="right" summary="">
      <tr>
        <td class="WebWorks_Company_Name_Bottom">
          <a href="notices.html">(c) Copyright Actuate Corporation 2013</a>
        </td>
      </tr>
    </table>
  </body>
</html>